473,406 Members | 2,705 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

mounting application on server(ODBC)

I have this simple login app. that i have developed on my local
machine that has successfully connected to the server Database and
authenticates users by a web_log_in table.

However I cannot put this application on the server for company wide
use.

This is the error: ERROR [IM00P] Specified driver could not be
loaded due to system error 5(Adaptive Server Anywhere 9.0)
I have a simple ODBC connection and I have changed nothing from the
original:

***************webconfig***********************
<connectionStrings>
<add name="ConnectionString"
connectionString="Dsn=DATABASE;uid=user;pwd=passwo rd"
providerName="System.Data.Odbc"/>
</connectionStrings>
*************************************************
Dim webstr As String =
ConfigurationManager.ConnectionStrings("Connection String").ConnectionString
Using con As New System.Data.Odbc.OdbcConnection(webstr)

con.Open()
Dim cmd As New System.Data.Odbc.OdbcCommand()
cmd.Connection = con
cmd.CommandType = Data.CommandType.Text
cmd.CommandText = "select count(*) from log_in_table
where username ='" & user & "' and password='" & pswrd & "'"
usercount = cmd.ExecuteScalar
con.Close()
End Using
*********************************************

Any Suggestions?
Jun 27 '08 #1
0 768

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Graham | last post by:
I need a SQL Server or ODBC package for Python. Can anyone help please? Have search the Python packages under Database and there is no reference to either SQL Server or ODBC. Thanks Graham
3
by: Chris | last post by:
Hi, I have two, similar SQL Server 7.0 databases (in the same SQL Server Group) that I use as the backend for two Access 2000 front end applications - one is the live version, the other is the...
2
by: john_20_28_2000 | last post by:
They are corrupt. I cannot get the odbc driver applet for sql server to open when I click add and I cannot configure any existing ones. And the usage of the drivers fail. Other ODBC drivers...
4
by: Andreas Lauffer | last post by:
Can anyone tell me advantages / disadvantages of DataDirect Server Wire ODBC-driver? Any experiences? What about redistribution? Andreas Lauffer, easySoft. GmbH, Germany
8
by: adserte | last post by:
I have a security related question. I was wondering how i can set up security so that for a table: a user can read all data in the table but only update and delete their own data (there is a...
0
by: flemmingk | last post by:
Using SQL Server 2005 Express on 23K, I am setting up a linked server using MSDASQL over ODBC (C/ODBC) to another server on out internal network. Linked server is a MBS Navision 3.7, Danish. When...
0
by: sudhaoncyberworld | last post by:
Dear Techies, I do have small issue on connecting oracle server from .net This is the code snippet public string strConString = "Driver={Microsoft ODBC for...
2
by: woakesd | last post by:
I've a query which happily returns a full set of data when run in SQL Studio but when I do the same query using IIS with Classic ASP connected via ODBC's SQL Server driver (not the native one)...
3
by: Bret Kuhns | last post by:
I recently started a co-op/internship at a company and they are looking to migrate a large legacy supported application from OLEDB to SQL Server. I'm doing prelim work in experimenting with the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.