jamiguel
asked on
How add the MSSQL driver to my Bde Administrator?
hi thanks.
and yes i know BDE is depreceated, by moment i have a solution that work wit Bde and MSSQL, then no choise i need by moment use BDE, thanks.
when i try create a new alias i see MSACCESS, STANDARD, SQL Server, then need add MSSQL driver how do it?
other ppl recommend me that try with SQL Server driver but this option havent some options (same as: SERVER NAME) that MSSQL have.
Thanks
and yes i know BDE is depreceated, by moment i have a solution that work wit Bde and MSSQL, then no choise i need by moment use BDE, thanks.
when i try create a new alias i see MSACCESS, STANDARD, SQL Server, then need add MSSQL driver how do it?
other ppl recommend me that try with SQL Server driver but this option havent some options (same as: SERVER NAME) that MSSQL have.
Thanks
What version of Delphi?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Go ahead and ask that this question be deleted, I am MrBaseball34 from Delphi Pages and know that you have already been told that by Norrit.
Please delete this Q
ow sorry, i guess that wasn't intended for me ?
ow sorry, i guess that wasn't intended for me ?
ASKER
i use delphi7
i am registered in a new pc (only the Windows XP) a fresh installation:
regsvr32 bdeinst.dll
when try create a New Alias i need choose MSSQL driver and havent.
Norrit Say:
"Just for the record:
SQL Server should be the same as MSSQL... At least, if somebody talks about SQL Server he's talking about MSSQL...
MySQL doesn't have any other name... But as what David said, BDE is deprecated... Don't use it, doesn't matter what project you're starting... Either choose ADO or ZEOS..."
but i need work by moment with BDE (i get a Image from SQL server, by moment only via BDE)
also i think have the solution: (need test):
<Chiu_Lee> go in c:\Program Files\Common Files\Borland Shared\BDE\ and check if you have a sql_mss.cnf file
<Chiu_Lee> and sqlmss32.dll
<Chiu_Lee> and do: regsvr32 sqlmss32.dll
in the night i test this.
thanks
i am registered in a new pc (only the Windows XP) a fresh installation:
regsvr32 bdeinst.dll
when try create a New Alias i need choose MSSQL driver and havent.
Norrit Say:
"Just for the record:
SQL Server should be the same as MSSQL... At least, if somebody talks about SQL Server he's talking about MSSQL...
MySQL doesn't have any other name... But as what David said, BDE is deprecated... Don't use it, doesn't matter what project you're starting... Either choose ADO or ZEOS..."
but i need work by moment with BDE (i get a Image from SQL server, by moment only via BDE)
also i think have the solution: (need test):
<Chiu_Lee> go in c:\Program Files\Common Files\Borland Shared\BDE\ and check if you have a sql_mss.cnf file
<Chiu_Lee> and sqlmss32.dll
<Chiu_Lee> and do: regsvr32 sqlmss32.dll
in the night i test this.
thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
do you have any programming experience at all ?
ASKER
Geert_Gruwez: 14 years..
not with Delphi and databases ... ?
ASKER
extract Images form dbs i have mmm 3 years of experience, but this problem, is strange,
you, and other members recommend me change the field type, ..... and have the info, and cant.
for me is a strange problem. and have you and other members, with more experience, have the info for connect, my question is tested?
Thanks
you, and other members recommend me change the field type, ..... and have the info, and cant.
for me is a strange problem. and have you and other members, with more experience, have the info for connect, my question is tested?
Thanks
the problem *is* the field type.
give it 1 byte and it stores 2 or 4, not 1.
give it 1 byte and it stores 2 or 4, not 1.
OK - I am unhappy - I subscribed to this site just for this answer and it does not help. I HAVE to use BDE bcause I am installing a legacy application that I cannot change so being told not to use BDE is not helpful. Also Sql Server is NOT the same as MSSQL. MSSQL is a native driver while SQL Server links to an ODBC driver. This application requires the native driver. MSSQL is not in the driver list and I want to know how to add it, which this thread said it would answer. but it doesn't. I am installing on a 64 bit OS and I am told on other sites that I have to use the .CFG file rather than the registry. I know how to add MSSQL via the registry but I do not know how to add it to the .CFG file. Can anyone help?
I have solved my own problem: On a 32 bit system you can add a driver to the BDE by means of the following registry entry ( MSSQL in this eample and on a 64 bit system simply replace SOFTWARE with SOFTWARE\Wow6432Node):
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine\Settings\DRIVERS\MSSQL]
[HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine\Settings\DRIVERS\MSSQL\DB OPEN]
"DATABASE NAME"=""
"SERVER NAME"="MSS_SERVER"
"USER NAME"="MYNAME"
"OPEN MODE"="READ/WRITE"
"SCHEMA CACHE SIZE"="8"
"BLOB EDIT LOGGING"=""
"LANGDRIVER"=""
"SQLQRYMODE"=""
"SQLPASSTHRU MODE"="SHARED AUTOCOMMIT"
"DATE MODE"="0"
"SCHEMA CACHE TIME"="-1"
"MAX QUERY TIME"="300"
"MAX ROWS"="-1"
"BATCH COUNT"="200"
"ENABLE SCHEMA CACHE"="FALSE"
"SCHEMA CACHE DIR"=""
"HOST NAME"=""
"APPLICATION NAME"=""
"NATIONAL LANG NAME"=""
"ENABLE BCD"="FALSE"
"TDS PACKET SIZE"="4096"
"BLOBS TO CACHE"="64"
"BLOB SIZE"="32"
[HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine\Settings\DRIVERS\MSSQL\INIT]
"VERSION"="4.0"
"TYPE"="SERVER"
"DLL32"="SQLMSS32.DLL"
"VENDOR INIT"=""
"CONNECT TIMEOUT"="60"
"TIMEOUT"="300"
"DRIVER FLAGS"=""
"TRACE MODE"="0"
"MAX DBPROCESSES"="31"
ASKER
thanks