SRPrice
Beginner
Joined: 19 Jul 2007
Posts: 18
|
 Posted: Sun Jan 17, 2010 12:54 am
ODBC Driver Manager - Data source name too long
|
Trying to convert one of my zmud script to CMUD 3.12
uses an .mdb database for mobs.
The alias i use to query the database appears to work ok. But the alias I use to write/edit stuff in the data base gives me the following error.
[Microsoft][ODBC Driver Manager] Data source name too long
I went digging around in my scripts and this is the source path.
MOBDBConn Variable is defined as follows:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\CMUD\Maps\Mobs.mdb
If I understand this correctly, this source length is ok when used to query, but for whatever reason, is too long in order to write to?
I'm not terribly familiar w/ database programming, but this seems odd to me.
In my query alias, I have the following to call out the query.
#VAR DB1 %comcreate( "ADODB.Recordset")
#CALL @DB1.Open( "SELECT ObjId FROM Mobs WHERE Name="'@mobs', @MOBDBConn)
In my write alias, I have the following to insert data into the db.
#VAR DB2 %comcreate( "ADODB.Recordset")
#CALL @DB2.Open( "INSERT INTO Mobs (ObjId, Name) VALUES" %roomvnum, ~'%replace( @mobs, "'", "''")~'~,@MOBDBConn)
Any ideas as to why it is giving the error saying the data source is too long or how to correct it? |
|
